<#-- This is a Freemarker Template for generating SQL DDL Files for the application -->
<#-- The following piece of code is INCOMPLETE -->

drop sequence linenum;
drop index productCat;
drop table lineitem;

create table orders (
      orderid int not null,
      userid varchar(80) not null,
      orderdate date not null,
      totalprice number(10,2) not null,
      constraint pk_orders primary key (orderid),
      constraint fk_orders_1 foreign key (userid) references account (userid)
);

create sequence ordernum increment by 1 cache 10000;

create index productCat on product (category);
